# _*_ coding utf-8 _*_
# FILENAME：requireSummaryModel.py
# DESCRIPTION: 零件需求汇总模型
# AUTH: jarvis zhang
# DATE: 2022/6/2 10:00 下午

from sqlalchemy import Column, String, Integer, DATETIME

from models.baseModel import BaseModel


# 零件需求主表
class RequireSummaryModel(BaseModel):
    # 表的名字:
    __tablename__ = 'require_summary'
    # 表的结构:
    status = Column(Integer, comment='状态：1：待运算 2：已运算')
    version_name = Column(String(255), index=True, comment='版本名称')
    factory_id = Column(Integer, comment='工厂ID')
    weld_version_id = Column(Integer, comment='参与运算的焊装零件版本编号')
    paint_version_id = Column(Integer, comment='参与运算的涂装零件版本编号')
    summary_version_id = Column(Integer, comment='参与运算的总装零件版本编号')
    # 添加表注释
    __table_args__ = ({'comment': '零件需求汇总主表'})

